Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	11121
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	380
Duplicate rows (%)	3.4%
Total size in memory	1.5 MiB
Average record size in memory	145.0 B

Variable types

Unsupported	3
Numeric	12
Boolean	1
Categorical	3

Alerts

Dataset has 380 (3.4%) duplicate rows	Duplicates
`acousticness` is highly overall correlated with `energy` and 1 other fields	High correlation
`energy` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`explicit` is highly overall correlated with `track_genre`	High correlation
`loudness` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`tempo` is highly overall correlated with `time_signature`	High correlation
`time_signature` is highly overall correlated with `tempo`	High correlation
`track_genre` is highly overall correlated with `explicit`	High correlation
`explicit` is highly imbalanced (54.1%)	Imbalance
`time_signature` is highly imbalanced (68.3%)	Imbalance
`artists` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`album_name` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`track_name` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`popularity` has 2151 (19.3%) zeros	Zeros
`key` has 1317 (11.8%) zeros	Zeros
`instrumentalness` has 4061 (36.5%) zeros	Zeros

Reproduction

Analysis started	2024-03-13 09:38:03.539862
Analysis finished	2024-03-13 09:38:50.641078
Duration	47.1 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

artists
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

album_name
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

track_name
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

popularity
Real number (ℝ)

ZEROS

Distinct	97
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.852621

Minimum	0
Maximum	100
Zeros	2151
Zeros (%)	19.3%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	15
median	42
Q3	59
95-th percentile	73
Maximum	100
Range	100
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	25.469493
Coefficient of variation (CV)	0.69111755
Kurtosis	-1.2515733
Mean	36.852621
Median Absolute Deviation (MAD)	20
Skewness	-0.1855906
Sum	409838
Variance	648.69509
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2151	19.3%
1	226	2.0%
57	225	2.0%
59	221	2.0%
63	220	2.0%
60	210	1.9%
62	210	1.9%
58	203	1.8%
44	188	1.7%
61	187	1.7%
Other values (87)	7080	63.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2151	19.3%
1	226	2.0%
2	91	0.8%
3	50	0.4%
4	33	0.3%
5	19	0.2%
6	5	< 0.1%
7	9	0.1%
8	3	< 0.1%
9	8	0.1%

Value	Count	Frequency (%)
100	1	< 0.1%
98	1	< 0.1%
96	1	< 0.1%
93	1	< 0.1%
92	3	< 0.1%
91	1	< 0.1%
90	3	< 0.1%
89	5	< 0.1%
88	6	0.1%
87	9	0.1%

duration_ms
Real number (ℝ)

Distinct	8264
Distinct (%)	74.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229669.85

Minimum	17826
Maximum	4120258
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	17826
5-th percentile	117468
Q1	173947
median	213520
Q3	264210
95-th percentile	376640
Maximum	4120258
Range	4102432
Interquartile range (IQR)	90263

Descriptive statistics

Standard deviation	120182.6
Coefficient of variation (CV)	0.52328418
Kurtosis	256.84214
Mean	229669.85
Median Absolute Deviation (MAD)	43186
Skewness	11.007197
Sum	2.5541584 × 10⁹
Variance	1.4443858 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
173947	45	0.4%
162897	38	0.3%
131733	34	0.3%
175986	30	0.3%
181360	28	0.3%
144080	26	0.2%
182520	25	0.2%
170344	18	0.2%
198626	18	0.2%
180000	18	0.2%
Other values (8254)	10841	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17826	1	< 0.1%
23506	1	< 0.1%
24000	1	< 0.1%
31106	1	< 0.1%
31824	1	< 0.1%
32986	1	< 0.1%
32996	1	< 0.1%
36006	1	< 0.1%
36453	1	< 0.1%
37680	1	< 0.1%

Value	Count	Frequency (%)
4120258	1	< 0.1%
3600014	1	< 0.1%
3340672	1	< 0.1%
2959346	1	< 0.1%
2733257	1	< 0.1%
1817447	1	< 0.1%
1798933	1	< 0.1%
1755311	2	< 0.1%
1736852	1	< 0.1%
1613160	1	< 0.1%

explicit
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 KiB

False	10042
True	1079

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	10042	90.3%
True	1079	9.7%

danceability
Real number (ℝ)

Distinct	914
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.59246235

Minimum	0
Maximum	0.974
Zeros	81
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.213
Q1	0.504
median	0.616
Q3	0.716
95-th percentile	0.835
Maximum	0.974
Range	0.974
Interquartile range (IQR)	0.212

Descriptive statistics

Standard deviation	0.1787108
Coefficient of variation (CV)	0.30164077
Kurtosis	0.77680355
Mean	0.59246235
Median Absolute Deviation (MAD)	0.105
Skewness	-0.87027896
Sum	6588.7738
Variance	0.031937549
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81	0.7%
0.647	70	0.6%
0.579	62	0.6%
0.71	61	0.5%
0.691	61	0.5%
0.524	56	0.5%
0.582	53	0.5%
0.813	52	0.5%
0.596	49	0.4%
0.593	49	0.4%
Other values (904)	10527	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	81	0.7%
0.0548	1	< 0.1%
0.055	1	< 0.1%
0.0555	1	< 0.1%
0.0558	1	< 0.1%
0.0578	1	< 0.1%
0.0601	1	< 0.1%
0.0602	1	< 0.1%
0.0611	1	< 0.1%
0.0625	1	< 0.1%

Value	Count	Frequency (%)
0.974	1	< 0.1%
0.965	1	< 0.1%
0.963	1	< 0.1%
0.96	1	< 0.1%
0.959	1	< 0.1%
0.957	1	< 0.1%
0.956	1	< 0.1%
0.955	1	< 0.1%
0.952	1	< 0.1%
0.95	2	< 0.1%

energy
Real number (ℝ)

HIGH CORRELATION

Distinct	1283
Distinct (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.60008693

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.11
Q1	0.427
median	0.632
Q3	0.808
95-th percentile	0.952
Maximum	1
Range	1
Interquartile range (IQR)	0.381

Descriptive statistics

Standard deviation	0.25451765
Coefficient of variation (CV)	0.42413463
Kurtosis	-0.58575814
Mean	0.60008693
Median Absolute Deviation (MAD)	0.189
Skewness	-0.49138125
Sum	6673.5667
Variance	0.064779232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.563	57	0.5%
0.876	51	0.5%
0.776	42	0.4%
0.608	40	0.4%
0.502	38	0.3%
0.287	38	0.3%
0.705	36	0.3%
0.415	35	0.3%
0.739	34	0.3%
0.75	32	0.3%
Other values (1273)	10718	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
2.01 × 10^-5	10	0.1%
2.02 × 10^-5	1	< 0.1%
2.03 × 10^-5	17	0.2%
3.05 × 10^-5	1	< 0.1%
4.28 × 10^-5	2	< 0.1%
5.9 × 10^-5	1	< 0.1%
6.03 × 10^-5	1	< 0.1%
6.19 × 10^-5	3	< 0.1%
7.99 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
1	9	0.1%
0.999	13	0.1%
0.998	28	0.3%
0.997	29	0.3%
0.996	18	0.2%
0.995	21	0.2%
0.994	14	0.1%
0.993	9	0.1%
0.992	5	< 0.1%
0.991	3	< 0.1%

key
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2098732

Minimum	0
Maximum	11
Zeros	1317
Zeros (%)	11.8%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.5625217
Coefficient of variation (CV)	0.68380199
Kurtosis	-1.2798167
Mean	5.2098732
Median Absolute Deviation (MAD)	3
Skewness	0.022488817
Sum	57939
Variance	12.691561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	1317	11.8%
7	1218	11.0%
1	1167	10.5%
2	1084	9.7%
5	994	8.9%
9	936	8.4%
11	851	7.7%
8	819	7.4%
6	798	7.2%
4	775	7.0%
Other values (2)	1162	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1317	11.8%
1	1167	10.5%
2	1084	9.7%
3	391	3.5%
4	775	7.0%
5	994	8.9%
6	798	7.2%
7	1218	11.0%
8	819	7.4%
9	936	8.4%

Value	Count	Frequency (%)
11	851	7.7%
10	771	6.9%
9	936	8.4%
8	819	7.4%
7	1218	11.0%
6	798	7.2%
5	994	8.9%
4	775	7.0%
3	391	3.5%
2	1084	9.7%

loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	6861
Distinct (%)	61.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-9.169955

Minimum	-49.307
Maximum	0.082
Zeros	0
Zeros (%)	0.0%
Negative	11119
Negative (%)	> 99.9%
Memory size	87.0 KiB

Quantile statistics

Minimum	-49.307
5-th percentile	-21.769
Q1	-10.747
median	-7.596
Q3	-5.472
95-th percentile	-3.147
Maximum	0.082
Range	49.389
Interquartile range (IQR)	5.275

Descriptive statistics

Standard deviation	6.0177163
Coefficient of variation (CV)	-0.65624273
Kurtosis	6.0218299
Mean	-9.169955
Median Absolute Deviation (MAD)	2.463
Skewness	-2.1861464
Sum	-101979.07
Variance	36.21291
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.135	44	0.4%
-5.662	41	0.4%
-7.57	36	0.3%
-12.472	31	0.3%
-4.177	28	0.3%
-8.169	27	0.2%
-6.264	26	0.2%
-4.67	20	0.2%
-5.926	19	0.2%
-4.457	19	0.2%
Other values (6851)	10830	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-49.307	1	< 0.1%
-46.251	1	< 0.1%
-43.504	1	< 0.1%
-43.046	3	< 0.1%
-42.995	1	< 0.1%
-42.631	1	< 0.1%
-41.739	1	< 0.1%
-41.531	1	< 0.1%
-40.843	1	< 0.1%
-40.795	1	< 0.1%

Value	Count	Frequency (%)
0.082	1	< 0.1%
0.025	1	< 0.1%
-0.079	1	< 0.1%
-0.108	1	< 0.1%
-0.155	1	< 0.1%
-0.173	1	< 0.1%
-0.488	1	< 0.1%
-0.5	1	< 0.1%
-0.562	1	< 0.1%
-0.564	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

1	7257
0	3864

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11121
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	7257	65.3%
0	3864	34.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	7257	65.3%
0	3864	34.7%

Most occurring characters

Value	Count	Frequency (%)
1	7257	65.3%
0	3864	34.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11121	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	7257	65.3%
0	3864	34.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	11121	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	7257	65.3%
0	3864	34.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11121	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	7257	65.3%
0	3864	34.7%

speechiness
Real number (ℝ)

Distinct	1239
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10750614

Minimum	0
Maximum	0.965
Zeros	81
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0279
Q1	0.0361
median	0.0498
Q3	0.0911
95-th percentile	0.36
Maximum	0.965
Range	0.965
Interquartile range (IQR)	0.055

Descriptive statistics

Standard deviation	0.17184471
Coefficient of variation (CV)	1.5984641
Kurtosis	14.748142
Mean	0.10750614
Median Absolute Deviation (MAD)	0.0174
Skewness	3.8094159
Sum	1195.5758
Variance	0.029530605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81	0.7%
0.102	73	0.7%
0.0341	67	0.6%
0.0323	55	0.5%
0.0324	51	0.5%
0.185	50	0.4%
0.0363	45	0.4%
0.0513	45	0.4%
0.0311	44	0.4%
0.0336	43	0.4%
Other values (1229)	10567	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	81	0.7%
0.0222	1	< 0.1%
0.0231	4	< 0.1%
0.0233	2	< 0.1%
0.0235	4	< 0.1%
0.0236	2	< 0.1%
0.0237	1	< 0.1%
0.0238	1	< 0.1%
0.0239	3	< 0.1%
0.024	4	< 0.1%

Value	Count	Frequency (%)
0.965	1	< 0.1%
0.963	1	< 0.1%
0.962	3	< 0.1%
0.961	1	< 0.1%
0.96	1	< 0.1%
0.959	2	< 0.1%
0.958	5	< 0.1%
0.957	3	< 0.1%
0.956	3	< 0.1%
0.955	6	0.1%

acousticness
Real number (ℝ)

HIGH CORRELATION

Distinct	2429
Distinct (%)	21.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.39411673

Minimum	0
Maximum	0.996
Zeros	14
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.00177
Q1	0.0635
median	0.307
Q3	0.73
95-th percentile	0.959
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.6665

Descriptive statistics

Standard deviation	0.33947942
Coefficient of variation (CV)	0.8613677
Kurtosis	-1.3672666
Mean	0.39411673
Median Absolute Deviation (MAD)	0.282
Skewness	0.3683011
Sum	4382.9722
Variance	0.11524628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.733	47	0.4%
0.881	46	0.4%
0.764	46	0.4%
0.994	45	0.4%
0.0254	45	0.4%
0.29	42	0.4%
0.777	42	0.4%
0.995	42	0.4%
0.993	36	0.3%
0.458	32	0.3%
Other values (2419)	10698	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	0.1%
1.01 × 10^-6	1	< 0.1%
1.14 × 10^-6	1	< 0.1%
1.17 × 10^-6	1	< 0.1%
1.21 × 10^-6	1	< 0.1%
1.46 × 10^-6	2	< 0.1%
1.62 × 10^-6	2	< 0.1%
1.91 × 10^-6	1	< 0.1%
2.26 × 10^-6	1	< 0.1%
2.65 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.996	11	0.1%
0.995	42	0.4%
0.994	45	0.4%
0.993	36	0.3%
0.992	21	0.2%
0.991	27	0.2%
0.99	24	0.2%
0.989	18	0.2%
0.988	14	0.1%
0.987	16	0.1%

instrumentalness
Real number (ℝ)

ZEROS

Distinct	3025
Distinct (%)	27.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13705639

Minimum	0
Maximum	1
Zeros	4061
Zeros (%)	36.5%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2.02 × 10^-5
Q3	0.0141
95-th percentile	0.897
Maximum	1
Range	1
Interquartile range (IQR)	0.0141

Descriptive statistics

Standard deviation	0.29612687
Coefficient of variation (CV)	2.1606207
Kurtosis	2.1094291
Mean	0.13705639
Median Absolute Deviation (MAD)	2.02 × 10^-5
Skewness	1.955798
Sum	1524.2041
Variance	0.087691126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4061	36.5%
9.71 × 10^-6	44	0.4%
3.59 × 10^-5	41	0.4%
1.68 × 10^-5	33	0.3%
1.38 × 10^-6	30	0.3%
1.81 × 10^-6	18	0.2%
1.32 × 10^-5	17	0.2%
3.87 × 10^-5	16	0.1%
0.895	15	0.1%
1.1 × 10^-5	15	0.1%
Other values (3015)	6831	61.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4061	36.5%
1 × 10^-6	2	< 0.1%
1.01 × 10^-6	7	0.1%
1.02 × 10^-6	4	< 0.1%
1.03 × 10^-6	4	< 0.1%
1.04 × 10^-6	4	< 0.1%
1.05 × 10^-6	3	< 0.1%
1.06 × 10^-6	3	< 0.1%
1.07 × 10^-6	8	0.1%
1.08 × 10^-6	2	< 0.1%

Value	Count	Frequency (%)
1	5	< 0.1%
0.999	10	0.1%
0.998	3	< 0.1%
0.997	5	< 0.1%
0.996	2	< 0.1%
0.995	8	0.1%
0.994	2	< 0.1%
0.993	4	< 0.1%
0.992	2	< 0.1%
0.991	7	0.1%

liveness
Real number (ℝ)

Distinct	1429
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21439206

Minimum	0
Maximum	0.994
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0604
Q1	0.0973
median	0.128
Q3	0.262
95-th percentile	0.715
Maximum	0.994
Range	0.994
Interquartile range (IQR)	0.1647

Descriptive statistics

Standard deviation	0.19877875
Coefficient of variation (CV)	0.927174
Kurtosis	3.9598438
Mean	0.21439206
Median Absolute Deviation (MAD)	0.046
Skewness	2.0878633
Sum	2384.2541
Variance	0.039512991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.11	154	1.4%
0.108	148	1.3%
0.111	140	1.3%
0.109	139	1.2%
0.112	131	1.2%
0.113	131	1.2%
0.107	127	1.1%
0.104	117	1.1%
0.106	101	0.9%
0.103	99	0.9%
Other values (1419)	9834	88.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.00925	1	< 0.1%
0.0137	1	< 0.1%
0.0151	1	< 0.1%
0.0153	1	< 0.1%
0.017	1	< 0.1%
0.0173	1	< 0.1%
0.0188	2	< 0.1%
0.0197	1	< 0.1%
0.0202	1	< 0.1%

Value	Count	Frequency (%)
0.994	1	< 0.1%
0.992	1	< 0.1%
0.99	1	< 0.1%
0.989	1	< 0.1%
0.984	1	< 0.1%
0.983	2	< 0.1%
0.981	4	< 0.1%
0.98	1	< 0.1%
0.979	2	< 0.1%
0.977	1	< 0.1%

valence
Real number (ℝ)

Distinct	1348
Distinct (%)	12.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.48992505

Minimum	0
Maximum	0.992
Zeros	90
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0535
Q1	0.288
median	0.49
Q3	0.699
95-th percentile	0.917
Maximum	0.992
Range	0.992
Interquartile range (IQR)	0.411

Descriptive statistics

Standard deviation	0.26121491
Coefficient of variation (CV)	0.5331732
Kurtosis	-0.97655548
Mean	0.48992505
Median Absolute Deviation (MAD)	0.206
Skewness	-0.023738117
Sum	5448.4565
Variance	0.068233227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	90	0.8%
1 × 10^-5	67	0.6%
0.961	62	0.6%
0.324	61	0.5%
0.64	55	0.5%
0.949	47	0.4%
0.639	42	0.4%
0.836	40	0.4%
0.56	37	0.3%
0.628	36	0.3%
Other values (1338)	10584	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	0.8%
1 × 10^-5	67	0.6%
0.000322	1	< 0.1%
0.000378	1	< 0.1%
0.000667	1	< 0.1%
0.000673	1	< 0.1%
0.000755	1	< 0.1%
0.000781	1	< 0.1%
0.00084	1	< 0.1%
0.000885	1	< 0.1%

Value	Count	Frequency (%)
0.992	1	< 0.1%
0.985	1	< 0.1%
0.983	1	< 0.1%
0.98	3	< 0.1%
0.979	2	< 0.1%
0.978	3	< 0.1%
0.977	6	0.1%
0.975	2	< 0.1%
0.973	4	< 0.1%
0.972	6	0.1%

tempo
Real number (ℝ)

HIGH CORRELATION

Distinct	7909
Distinct (%)	71.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.29995

Minimum	0
Maximum	220.081
Zeros	81
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	75.157
Q1	94.275
median	116.03
Q3	135.039
95-th percentile	171.698
Maximum	220.081
Range	220.081
Interquartile range (IQR)	40.764

Descriptive statistics

Standard deviation	30.148845
Coefficient of variation (CV)	0.25923353
Kurtosis	0.86364119
Mean	116.29995
Median Absolute Deviation (MAD)	20.826
Skewness	-0.0092707951
Sum	1293371.7
Variance	908.95287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81	0.7%
106.998	45	0.4%
151.925	38	0.3%
76.783	34	0.3%
77.117	30	0.3%
128.89	27	0.2%
146.861	26	0.2%
137.494	25	0.2%
91.921	19	0.2%
119.935	18	0.2%
Other values (7899)	10778	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	81	0.7%
30.2	1	< 0.1%
35.392	1	< 0.1%
43.844	1	< 0.1%
44.153	1	< 0.1%
45.664	1	< 0.1%
45.857	1	< 0.1%
46.496	1	< 0.1%
46.592	1	< 0.1%
47.604	1	< 0.1%

Value	Count	Frequency (%)
220.081	3	< 0.1%
220.039	1	< 0.1%
219.693	1	< 0.1%
213.848	1	< 0.1%
213.778	1	< 0.1%
208.038	2	< 0.1%
208.001	1	< 0.1%
207.348	1	< 0.1%
207.266	1	< 0.1%
204.961	1	< 0.1%

time_signature
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

4	9668
3	1008
5	205
1	159
0	81

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11121
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	3
5th row	4

Common Values

Value	Count	Frequency (%)
4	9668	86.9%
3	1008	9.1%
5	205	1.8%
1	159	1.4%
0	81	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	9668	86.9%
3	1008	9.1%
5	205	1.8%
1	159	1.4%
0	81	0.7%

Most occurring characters

Value	Count	Frequency (%)
4	9668	86.9%
3	1008	9.1%
5	205	1.8%
1	159	1.4%
0	81	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11121	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	9668	86.9%
3	1008	9.1%
5	205	1.8%
1	159	1.4%
0	81	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	11121	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	9668	86.9%
3	1008	9.1%
5	205	1.8%
1	159	1.4%
0	81	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11121	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	9668	86.9%
3	1008	9.1%
5	205	1.8%
1	159	1.4%
0	81	0.7%

track_genre
Categorical

HIGH CORRELATION

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

indian	999
pop-film	889
afrobeat	782
k-pop	697
sleep	614
Other values (14)	7140

Length

Max length	9
Median length	8
Mean length	6.0356083
Min length	3

Characters and Unicode

Total characters	67122
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	acoustic
2nd row	acoustic
3rd row	acoustic
4th row	acoustic
5th row	acoustic

Common Values

Value	Count	Frequency (%)
indian	999	9.0%
pop-film	889	8.0%
afrobeat	782	7.0%
k-pop	697	6.3%
sleep	614	5.5%
breakbeat	591	5.3%
acoustic	589	5.3%
blues	583	5.2%
chill	560	5.0%
disco	524	4.7%
Other values (9)	4293	38.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
indian	999	9.0%
pop-film	889	8.0%
afrobeat	782	7.0%
k-pop	697	6.3%
sleep	614	5.5%
breakbeat	591	5.3%
acoustic	589	5.3%
blues	583	5.2%
chill	560	5.0%
disco	524	4.7%
Other values (9)	4293	38.6%

Most occurring characters

Value	Count	Frequency (%)
a	6566	9.8%
l	5694	8.5%
i	5557	8.3%
o	5515	8.2%
p	5308	7.9%
e	4765	7.1%
c	4731	7.0%
s	4088	6.1%
b	3058	4.6%
d	2803	4.2%
Other values (10)	19037	28.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	65023	96.9%
Dash Punctuation	2099	3.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6566	10.1%
l	5694	8.8%
i	5557	8.5%
o	5515	8.5%
p	5308	8.2%
e	4765	7.3%
c	4731	7.3%
s	4088	6.3%
b	3058	4.7%
d	2803	4.3%
Other values (9)	16938	26.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2099	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	65023	96.9%
Common	2099	3.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6566	10.1%
l	5694	8.8%
i	5557	8.5%
o	5515	8.5%
p	5308	8.2%
e	4765	7.3%
c	4731	7.3%
s	4088	6.3%
b	3058	4.7%
d	2803	4.3%
Other values (9)	16938	26.0%

Common

Value	Count	Frequency (%)
-	2099	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	67122	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	6566	9.8%
l	5694	8.5%
i	5557	8.3%
o	5515	8.2%
p	5308	7.9%
e	4765	7.1%
c	4731	7.0%
s	4088	6.1%
b	3058	4.6%
d	2803	4.2%
Other values (10)	19037	28.4%

Auto

Heatmap
Table

	acousticness	danceability	duration_ms	energy	explicit	instrumentalness	key	liveness	loudness	mode	popularity	speechiness	tempo	time_signature	track_genre	valence
acousticness	1.000	-0.347	-0.091	-0.623	0.111	0.032	-0.042	0.014	-0.567	0.111	0.011	-0.141	-0.224	0.149	0.290	-0.255
danceability	-0.347	1.000	-0.070	0.259	0.215	-0.167	0.048	-0.146	0.349	0.076	0.066	0.225	0.110	0.380	0.309	0.496
duration_ms	-0.091	-0.070	1.000	0.152	0.000	0.053	0.015	-0.046	0.074	0.018	0.089	-0.121	0.064	0.052	0.075	0.038
energy	-0.623	0.259	0.152	1.000	0.129	-0.111	0.050	0.171	0.727	0.102	-0.070	0.333	0.215	0.190	0.302	0.391
explicit	0.111	0.215	0.000	0.129	1.000	-0.182	0.000	0.128	0.028	0.000	-0.013	0.315	-0.036	0.068	0.548	-0.029
instrumentalness	0.032	-0.167	0.053	-0.111	-0.182	1.000	-0.002	-0.108	-0.322	0.018	-0.085	-0.159	-0.025	0.123	0.247	-0.262
key	-0.042	0.048	0.015	0.050	0.000	-0.002	1.000	0.017	0.034	0.245	0.004	0.064	0.020	0.032	0.066	0.059
liveness	0.014	-0.146	-0.046	0.171	0.128	-0.108	0.017	1.000	0.034	0.027	-0.083	0.156	-0.020	0.107	0.210	-0.022
loudness	-0.567	0.349	0.074	0.727	0.028	-0.322	0.034	0.034	1.000	0.067	0.032	0.168	0.198	0.194	0.301	0.375
mode	0.111	0.076	0.018	0.102	0.000	0.018	0.245	0.027	0.067	1.000	-0.086	-0.076	-0.025	0.027	0.205	-0.026
popularity	0.011	0.066	0.089	-0.070	-0.013	-0.085	0.004	-0.083	0.032	-0.086	1.000	-0.036	-0.002	0.108	0.455	-0.064
speechiness	-0.141	0.225	-0.121	0.333	0.315	-0.159	0.064	0.156	0.168	-0.076	-0.036	1.000	0.116	0.119	0.304	0.153
tempo	-0.224	0.110	0.064	0.215	-0.036	-0.025	0.020	-0.020	0.198	-0.025	-0.002	0.116	1.000	0.508	0.185	0.159
time_signature	0.149	0.380	0.052	0.190	0.068	0.123	0.032	0.107	0.194	0.027	0.108	0.119	0.508	1.000	0.250	0.168
track_genre	0.290	0.309	0.075	0.302	0.548	0.247	0.066	0.210	0.301	0.205	0.455	0.304	0.185	0.250	1.000	-0.097
valence	-0.255	0.496	0.038	0.391	-0.029	-0.262	0.059	-0.022	0.375	-0.026	-0.064	0.153	0.159	0.168	-0.097	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	artists	album_name	track_name	popularity	duration_ms	explicit	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	track_genre
0	Gen Hoshino	Comedy	Comedy	73	230666	False	0.676	0.4610	1	-6.746	0	0.1430	0.0322	0.000001	0.3580	0.7150	87.917	4	acoustic
1	Ben Woodward	Ghost (Acoustic)	Ghost - Acoustic	55	149610	False	0.420	0.1660	1	-17.235	1	0.0763	0.9240	0.000006	0.1010	0.2670	77.489	4	acoustic
2	Ingrid Michaelson;ZAYN	To Begin Again	To Begin Again	57	210826	False	0.438	0.3590	0	-9.734	1	0.0557	0.2100	0.000000	0.1170	0.1200	76.332	4	acoustic
3	Kina Grannis	Crazy Rich Asians (Original Motion Picture Soundtrack)	Can't Help Falling In Love	71	201933	False	0.266	0.0596	0	-18.515	1	0.0363	0.9050	0.000071	0.1320	0.1430	181.740	3	acoustic
4	Chord Overstreet	Hold On	Hold On	82	198853	False	0.618	0.4430	2	-9.681	1	0.0526	0.4690	0.000000	0.0829	0.1670	119.949	4	acoustic
5	Tyrone Wells	Days I Will Remember	Days I Will Remember	58	214240	False	0.688	0.4810	6	-8.807	1	0.1050	0.2890	0.000000	0.1890	0.6660	98.017	4	acoustic
6	A Great Big World;Christina Aguilera	Is There Anybody Out There?	Say Something	74	229400	False	0.407	0.1470	2	-8.822	1	0.0355	0.8570	0.000003	0.0913	0.0765	141.284	3	acoustic
7	Jason Mraz	We Sing. We Dance. We Steal Things.	I'm Yours	80	242946	False	0.703	0.4440	11	-9.331	1	0.0417	0.5590	0.000000	0.0973	0.7120	150.960	4	acoustic
8	Jason Mraz;Colbie Caillat	We Sing. We Dance. We Steal Things.	Lucky	74	189613	False	0.625	0.4140	0	-8.700	1	0.0369	0.2940	0.000000	0.1510	0.6690	130.088	4	acoustic
9	Ross Copperman	Hunger	Hunger	56	205594	False	0.442	0.6320	1	-6.770	1	0.0295	0.4260	0.004190	0.0735	0.1960	78.899	4	acoustic

	artists	album_name	track_name	popularity	duration_ms	explicit	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	track_genre
11111	Jamie Miller	I Lost Myself In Loving You	I Lost Myself In Loving You	67	201306	False	0.456	0.615	1	-5.454	1	0.0529	0.61400	0.000000	0.0908	0.4160	78.461	4	soul
11112	Brandy;Monica	Gourmet Soul	The Boy Is Mine	0	239683	False	0.659	0.726	1	-6.013	0	0.0415	0.30800	0.000013	0.1390	0.7090	93.044	4	soul
11113	Jessie Ware	Autumn Vibes 2022	Mirage (Donâ€™t Stop)	0	287226	False	0.796	0.710	2	-6.683	1	0.0838	0.10900	0.000846	0.1240	0.6210	112.976	4	soul
11114	Celeste	Autumn Vibe	Tonight Tonight	1	219440	False	0.611	0.834	11	-4.528	0	0.0299	0.05440	0.000016	0.2320	0.6430	109.997	4	soul
11115	Faith Evans	Gourmet Soul	You Used to Love Me	0	269173	False	0.702	0.458	0	-8.195	1	0.0348	0.24700	0.000002	0.1260	0.6790	89.266	4	soul
11116	Faith Evans;The Notorious B.I.G.	Mellow Bars R'n'B	One in the Same	0	205706	True	0.461	0.540	1	-7.385	0	0.0629	0.26800	0.000000	0.3420	0.1070	136.562	5	soul
11117	Brandy;Mase	Pop Station	Top of the World	0	281506	False	0.839	0.621	1	-5.739	1	0.1320	0.00301	0.033800	0.1050	0.8550	98.015	4	soul
11118	Jessie Ware	AnÃmate, es viernes	Please - Single Edit	0	219933	False	0.665	0.690	7	-7.275	1	0.0369	0.03250	0.014700	0.1160	0.4540	120.032	4	soul
11119	Commodores	Coffee Break	Three Times A Lady	1	397586	False	0.486	0.242	8	-12.029	1	0.0260	0.80900	0.000326	0.1770	0.0855	74.782	3	soul
11120	Commodores	On air 70's Hits	Easy	1	256545	False	0.568	0.575	10	-7.769	0	0.0290	0.12600	0.000100	0.1140	0.3330	133.093	4	soul

Most frequently occurring

	duration_ms	explicit	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	track_genre	# duplicates
67	162897	False	0.647	0.876	10	-5.662	1	0.1850	0.8810	0.000036	0.2600	0.949	151.925	4	blues	36
14	131733	False	0.579	0.502	8	-7.570	1	0.0513	0.7330	0.000000	0.2810	0.836	76.783	4	blues	32
106	175986	False	0.593	0.287	1	-12.472	1	0.0469	0.7640	0.000000	0.1530	0.639	77.117	4	blues	29
30	144080	False	0.691	0.776	0	-4.177	1	0.0341	0.4580	0.000017	0.3300	0.961	146.861	4	soul	26
123	181360	False	0.582	0.705	3	-8.169	1	0.0539	0.2900	0.000001	0.7970	0.640	128.890	4	soul	25
127	182520	False	0.775	0.608	7	-6.264	1	0.1280	0.1280	0.000000	0.0895	0.560	137.494	4	dance	23
100	173947	True	0.905	0.563	8	-6.135	1	0.1020	0.0254	0.000010	0.1130	0.324	106.998	4	hip-hop	20
101	173947	True	0.905	0.563	8	-6.135	1	0.1020	0.0254	0.000010	0.1130	0.324	106.998	4	k-pop	20
185	198626	False	0.524	0.739	0	-6.681	1	0.0386	0.2150	0.000000	0.0636	0.480	83.095	4	soul	17
94	171773	False	0.596	0.315	8	-9.175	1	0.0428	0.9610	0.000000	0.2580	0.640	119.935	4	blues	16

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring